EMT Practice Test

1. Question Content...

---

Question1: Which command sets the Virtual Warehouse for a session?

Question2: Which feature is only available in the Enterprise or higher editions of Snowflake?

Question3: How are serverless features billed?

Question4: Where would a Snowflake user find information about query activity from 90 days ago?

Question5: Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

Question6: The Snowflake Search Optimization Services supports improved performance of which kind of query?

Question7: Which file format will keep floating-point numbers from being truncated when data is unloaded?

Question8: Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

Question9: Which of the following are characteristics of security in Snowflake?

Question10: What can a Snowflake user do with the information included in the details section of a Query Profile?

Question11: Which command is used to unload data from a Snowflake table into a file in a stage?

Question12: What role is required to use Partner Connect?

Question13: Which cache type is used to cache data output from SQL queries?

Question14: When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Question15: Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Question16: A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?

Question17: What is a key feature of Snowflake architecture?

Question18: What can a Snowflake user do in the Admin area of Snowsight?

Question19: Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Question20: Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

Question21: Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

Question22: By default, which Snowflake role is required to create a share?

Question23: What is the maximum Time Travel retention period for a temporary Snowflake table?

Question24: Which minimum Snowflake edition allows for a dedicated metadata store?

Question25: What is the recommended compressed file size range for continuous data loads using Snowpipe?

Question26: Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Question27: Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

Question28: What is the recommended file sizing for data loading using Snowpipe?

Question29: How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

Question30: What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?

Question31: How often are encryption keys automatically rotated by Snowflake?

Question32: Which of the following can be executed/called with Snowpipe?

Question33: What are value types that a VARIANT column can store? (Select TWO)

Question34: Which of the following commands cannot be used within a reader account?

Question35: What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

Question36: Which statement MOST accurately describes clustering in Snowflake?

Question37: Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

Question38: What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

Question39: What happens when a cloned table is replicated to a secondary database? (Select TWO)

Question40: Which statement describes pruning?

Question41: Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

Question42: Which of the following are considerations when using a directory table when working with unstructured data?
(Choose two.)

Question43: How can a Snowflake user optimize query performance in Snowflake? (Select TWO).

Question44: Which command can be used to load data into an internal stage?

Question45: What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).

Question46: What are ways to create and manage data shares in Snowflake? (Select TWO)

Question47: Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Question48: What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

Question49: A materialized view should be created when which of the following occurs? (Choose two.)

Question50: What happens when a database is cloned?

Question51: What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

Question52: Which feature allows a user the ability to control the organization of data in a micro-partition?

Question53: When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Question54: What is the MAXIMUM size limit for a record of a VARIANT data type?

Question55: In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

Question56: Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

Question57: What does Snowflake's search optimization service support?

Question58: What column type does a Kafka connector store formatted information in a single column?

Question59: The is the minimum Fail-safe retention time period for transient tables?

Question60: What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

Question61: What is a responsibility of Snowflake's virtual warehouses?

Question62: Which of the following compute resources or features are managed by Snowflake? (Select TWO).

Question63: A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?

Question64: Which of the following significantly improves the performance of selective point lookup queries on a table?

Question65: Which Snowflake technique can be used to improve the performance of a query?

Question66: What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake?
(Choose two.)

Question67: Where can a user find and review the failed logins of a specific user for the past 30 days?

Question68: Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

Question69: True or False: A Virtual Warehouse can be resized while suspended.

Question70: The fail-safe retention period is how many days?

Question71: Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Question72: Which Snowflake architectural layer is responsible for a query execution plan?

Question73: The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

Question74: Which command can be used to stage local files from which Snowflake interface?

Question75: A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?

Question76: How does a scoped URL expire?

Question77: A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

Question78: User-level network policies can be created by which of the following roles? (Select TWO).

Question79: What happens when an external or an internal stage is dropped? (Select TWO).

Question80: What features does Snowflake Time Travel enable?

Question81: Which of the following can be used when unloading data from Snowflake? (Choose two.)

Question82: What is the minimum Snowflake edition required to use Dynamic Data Masking?

Question83: What does Snowflake recommend regarding database object ownership? (Select TWO).

Question84: Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Question85: Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

Question86: What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

Question87: Where is Snowflake metadata stored?

Question88: What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

Question89: Which Snowflake URL type is used by directory tables?

Question90: What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

Question91: A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

Question92: Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Question93: A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

Question94: How can a data provider ensure that a data consumer is going to have access to the required objects?

Question95: Which of the following accurately describes shares?

Question96: For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

Question97: When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

Question98: What feature can be used to reorganize a very large table on one or more columns?

Question99: Which of the following describes external functions in Snowflake?

Question100: Which features make up Snowflake's column level security? (Select TWO).

Question101: Which of the following describes a Snowflake stored procedure?

Question102: What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

Question103: Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Question104: By definition, a secure view is exposed only to users with what privilege?

Question105: Which Snowflake tool would be BEST to troubleshoot network connectivity?

Question106: What affects whether the query results cache can be used?

Question107: What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Question108: Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

Question109: Which of the following are benefits of micro-partitioning? (Select TWO)

Question110: Which of the following is the Snowflake Account_Usage.Metering_History view used for?

Question111: The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

Question112: Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

Question113: Which data type can be used to store geospatial data in Snowflake?

Question114: If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

Question115: A materialized view should be created when which of the following occurs? (Choose two.)

Question116: In which use cases does Snowflake apply egress charges?

Question117: Which statement about billing applies to Snowflake credits?

Question118: Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Question119: What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Question120: A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?

Question121: Which user object property requires contacting Snowflake Support in order to set a value for it?

Question122: True or False: Snowpipe via REST API can only reference External Stages as source.

Question123: Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Question124: True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

Question125: A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?

Question126: When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

Question127: Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?

Question128: What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

Question129: Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Question130: Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Question131: Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

Question132: What can a Snowflake user do in the Activity section in Snowsight?

Question133: True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Question134: How long is the Fail-safe period for temporary and transient tables?

Question135: Which stage type can be altered and dropped?

Question136: When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

Question137: What is the purpose of multi-cluster virtual warehouses?

Question138: What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)